#coding:utf-8
import calendar
import datetime
import time
import uuid


# 获取所有周一的日期
def getOneDay():
    toDay = datetime.date.today()
    week = datetime.date.today().weekday()
    firstDay = toDay - datetime.timedelta(week)
    print firstDay
    print toDay
    pass

def createSql():
    #在线管理员id:    5e0f09fd7e1d47d19ae498a40d963973
    list = []
    admins = ['7c4ed14689c1425987ff962ab78f2150',
                '8ba227a531ff46ed9e3b013c4850607e',
                'b01c714041904284b915d9fc7fac30d9',
                'd509220038e94210a3bb113bac38bb2e',
                '1239a2976af147cd9df426dec9fad7er',
                '1239a2976af147cd9df426dec9fad7qw',
                '1239a2976af147cd9df426dec9fad7vr',
                '1239a2976af147cd9df426dec9fad7wq',
                '1239a2976af147cd9df426dec9fad7wr',
                '5e0f09fd7e1d47d19ae498a40d963973'
              ];
    for admin in admins:
        mangeId = admin

        # for i in range(1311,1314):
        #     uu = str(uuid.uuid4()).replace("-", "")
        #     sql = "insert into sys_role_function_rel value ('"+uu+"','"+str(i)+"','"+mangeId+"');"
        #     list.append(sql)
        #     print i
        for i in range(1323,1325):
            uu = str(uuid.uuid4()).replace("-", "")
            sql = "insert into sys_role_function_rel value ('"+uu+"','"+str(i)+"','"+mangeId+"');"
            list.append(sql)
            print i
    for i in list:
        print i

if  __name__=="__main__":
    createSql()
    pass